home *** CD-ROM | disk | FTP | other *** search
/ PC World Komputer 2010 April / PCWorld0410.iso / pluginy Firefox / 5817 / 5817.xpi / chrome / content / menuSqlHelper.xul < prev    next >
Extensible Markup Language  |  2010-02-11  |  7KB  |  119 lines
  1. <?xml version="1.0"?>
  2. <overlay id="tabDbInfo-overlay"
  3.       xmlns="http://www.mozilla.org/keymaster/gatekeeper/there.is.only.xul">
  4.  
  5.   <menubar id="sql-help-menubar">
  6.     <menu id="sql-help-alter-menu" label="Select">
  7.       <menupopup>
  8.         <menuitem oncommand="SQLiteManager.setSqlText(this.value)" 
  9.           label="SELECT * FROM tableName" 
  10.           value="SELECT * FROM tableName"/>
  11.         <menuitem oncommand="SQLiteManager.setSqlText(this.value)" 
  12.           label="SELECT with WHERE clause" 
  13.           value="SELECT [ALL | DISTINCT] result FROM table-list WHERE expr"/>
  14.         <menuitem oncommand="SQLiteManager.setSqlText(this.value)" 
  15.           label="SELECT (general)" 
  16.           value="SELECT [ALL | DISTINCT] result [FROM table-list] [WHERE expr] [GROUP BY expr-list] [HAVING expr] [compound-op select]* [ORDER BY sort-expr-list] [LIMIT integer [( OFFSET | , ) integer]]"/>
  17.       </menupopup>
  18.     </menu>
  19.     <toolbarseparator/>
  20.     <menu id="sql-help-drop-menu" label="Data Manipulation">
  21.       <menupopup>
  22.         <menuitem oncommand="SQLiteManager.setSqlText(this.value)" 
  23.           label="DELETE" 
  24.           value="DELETE FROM tableName [WHERE expr]"/>
  25.         <menuitem oncommand="SQLiteManager.setSqlText(this.value)" 
  26.           label="INSERT values" 
  27.           value="INSERT INTO tableName [(column-list)] VALUES(value-list)"/>
  28.         <menuitem oncommand="SQLiteManager.setSqlText(this.value)" 
  29.           label="INSERT using select" 
  30.           value="INSERT INTO tableName [(column-list)] select-statement"/>
  31.         <menuitem oncommand="SQLiteManager.setSqlText(this.value)" 
  32.           label="UPDATE" 
  33.           value="UPDATE tableName SET assignment [, assignment]* [WHERE expr]"/>
  34.         <menuitem oncommand="SQLiteManager.setSqlText(this.value)" 
  35.           label="REPLACE values" 
  36.           value="REPLACE INTO tableName [(column-list)] VALUES(value-list)"/>
  37.         <menuitem oncommand="SQLiteManager.setSqlText(this.value)" 
  38.           label="REPLACE using select" 
  39.           value="REPLACE INTO tableName [(column-list)] select-statement"/>
  40.       </menupopup>
  41.     </menu>
  42.     <toolbarseparator/>
  43.     <menu id="sql-help-drop-menu" label="Create/Alter">
  44.       <menupopup>
  45.         <menuitem oncommand="SQLiteManager.setSqlText(this.value)" 
  46.           label="CREATE TABLE" 
  47.           value="CREATE TABLE IF NOT EXISTS tableName (column-def [, column-def]* [, constraint]*"/>
  48.         <menuitem oncommand="SQLiteManager.setSqlText(this.value)" 
  49.           label="CREATE TEMP TABLE" 
  50.           value="CREATE TEMP TABLE IF NOT EXISTS tableName (column-def [, column-def]* [, constraint]*"/>
  51.         <menuitem oncommand="SQLiteManager.setSqlText(this.value)" 
  52.           label="CREATE TABLE x AS select-statement" 
  53.           value="CREATE TABLE tableName AS select-statement"/>
  54.         <menuitem oncommand="SQLiteManager.setSqlText(this.value)" 
  55.           label="CREATE TEMP TABLE x AS select-statement" 
  56.           value="CREATE TEMP TABLE tableName AS select-statement"/>
  57.         <menuseparator/>
  58.         <menuitem oncommand="SQLiteManager.setSqlText(this.value)" 
  59.           label="ALTER TABLE x RENAME TO y" 
  60.           value="ALTER TABLE old_tableName RENAME TO new_tableName"/>
  61.         <menuitem oncommand="SQLiteManager.setSqlText(this.value)" 
  62.           label="ALTER TABLE x ADD COLUMN column-def" 
  63.           value="ALTER TABLE x ADD COLUMN column-def"/>
  64.         <menuseparator/>
  65.         <menuitem oncommand="SQLiteManager.setSqlText(this.value)" 
  66.           label="CREATE INDEX" 
  67.           value="CREATE INDEX IF NOT EXISTS indexName ON tableName ( columnName [, columnName]* )"/>
  68.         <menuitem oncommand="SQLiteManager.setSqlText(this.value)" 
  69.           label="CREATE UNIQUE INDEX" 
  70.           value="CREATE UNIQUE INDEX IF NOT EXISTS indexName ON tableName ( columnName [, columnName]* )"/>
  71.         <menuitem oncommand="SQLiteManager.setSqlText(this.value)" 
  72.           label="CREATE VIEW" 
  73.           value="CREATE [TEMPORARY] VIEW IF NOT EXISTS viewName AS selectStatement"/>
  74.         <menuitem oncommand="SQLiteManager.setSqlText(this.value)" 
  75.           label="CREATE TRIGGER" 
  76.           value="CREATE [TEMPORARY] TRIGGER IF NOT EXISTS triggerName [ BEFORE | AFTER ] DELETE|INSERT|UPDATE ON tableName [ FOR EACH ROW ] [ WHEN expression ] BEGIN  semicolon-terminated-update-delete-select-or-insert-statements END"/>
  77.       </menupopup>
  78.     </menu>
  79.     <toolbarseparator/>
  80.     <menu id="sql-help-drop-menu" label="Drop">
  81.       <menupopup>
  82.         <menuitem oncommand="SQLiteManager.setSqlText(this.value)" 
  83.           label="DROP TABLE" value="DROP TABLE tableName"/>
  84.         <menuitem oncommand="SQLiteManager.setSqlText(this.value)" 
  85.           label="DROP INDEX" value="DROP INDEX indexName"/>
  86.         <menuitem oncommand="SQLiteManager.setSqlText(this.value)" 
  87.           label="DROP VIEW" value="DROP VIEW viewName"/>
  88.         <menuitem oncommand="SQLiteManager.setSqlText(this.value)" 
  89.           label="DROP TRIGGER" value="DROP TRIGGER triggerName"/>
  90.       </menupopup>
  91.     </menu>
  92.     <toolbarseparator/>
  93.     <menu id="sql-help-drop-menu" label="ReIndex">
  94.       <menupopup>
  95.         <menuitem oncommand="SQLiteManager.setSqlText(this.label)" label="REINDEX tableName"/>
  96.         <menuitem oncommand="SQLiteManager.setSqlText(this.label)" label="REINDEX indexName"/>
  97.         <menuitem oncommand="SQLiteManager.setSqlText(this.label)" label="REINDEX collationName"/>
  98.       </menupopup>
  99.     </menu>
  100.     <toolbarseparator/>
  101.     <menu id="sql-help-pragma-menu" label="PRAGMA">
  102.       <menupopup>
  103.         <menuitem oncommand="SQLiteManager.setSqlText(this.value)" 
  104.           label="PRAGMA table_info" value="PRAGMA table_info (tableName)"/>
  105.         <menuitem oncommand="SQLiteManager.setSqlText(this.value)" 
  106.           label="PRAGMA index_list" value="PRAGMA index_list (tableName)"/>
  107.         <menuitem oncommand="SQLiteManager.setSqlText(this.value)" 
  108.           label="PRAGMA foreign_key_list" value="PRAGMA foreign_key_list (tableName)"/>
  109.         <menuseparator/>
  110.         <menuitem oncommand="SQLiteManager.setSqlText(this.value)" 
  111.           label="PRAGMA index_info" value="PRAGMA index_info (indexName)"/>
  112.         <menuseparator/>
  113.         <menuitem oncommand="SQLiteManager.setSqlText(this.label)" label="PRAGMA database_list"/>
  114.         <menuitem oncommand="SQLiteManager.setSqlText(this.label)" label="PRAGMA collation_list"/>
  115.       </menupopup>
  116.     </menu>
  117.   </menubar>
  118. </overlay>
  119.